Data Dictionary for the
PAD Program Manager

Access 2000 Database
Current Development Status on 12 March 2004

The following are the primary data collection tables, and are prefixed with the identifier 'tbl'

tblAED

Name	Type	Size
AEDRecord *	Long Integer	4
FacilityRecord	Long Integer	4
Brand	Long Integer	4
ModelNumber	Text	20
SerialNumber	Text	20
Location	Memo	-
UserDef1	Text	250
UserDef2	Text	250
DateStart	Date/Time	8
DateEnd	Date/Time	8

tblApplication

Name	Type	Size
ApplicationRecord *	Long Integer	4
FacilityRecord	Long Integer	4
Type	Byte	1
ReceivedDate	Date/Time	8
Approved	Yes/No	1
ApprovalDate	Date/Time	8
CertificationNumber	Text	255
ExpirationDate	Date/Time	8
RejectionAddress	Yes/No	1
RejectionTraining	Yes/No	1
RejectionCoordinatorSignature	Yes/No	1
RejectionCoordinatorNotCurrent	Yes/No	1
RejectionMedDirectorSignature	Yes/No	1
RejectionMedDirectorLicense	Yes/No	1
RejectionMedDirectorAddress	Yes/No	1
RejectionAEDBrand	Yes/No	1
RejectionAEDModel	Yes/No	1
RejectionAEDSerial	Yes/No	1
RejectionAEDLocation	Yes/No	1
RejectionElectrodeBrand	Yes/No	1
RejectionElectrodeManufacturer	Yes/No	1
RejectionElectrodeLotNumber	Yes/No	1
RejectionElectrodeExpDate	Yes/No	1
RejectionPayment	Yes/No	1
RejectionOther	Text	250
RejectionSent	Yes/No	1
Reviewer	Text	50
ReviewDate	Date/Time	8
NumberEmployees	Long Integer	4
Number of Employees Trained	Long Integer	4
Number of Employees to be Trained	Long Integer	4
Fee	Currency	8
Paid	Yes/No	1
PaymentReceived	Date/Time	8
PaymentType	Byte	1
CheckNumber	Text	20

tblBattery

Name	Type	Size
BatteryRecord	Long Integer	4
FacilityRecord	Long Integer	4
BatteryBrandCode	Long Integer	4
BatteryModelNumber	Text	20
BatterySerialNumber	Text	20
BatteryLotNumber	Text	20
BatteryExpirationDate	Date/Time	8
CoordinatorNotified	Yes/No	1
BatteryAEDSerialNumber	Text	20
BatteryNotes	Memo	-
UserDef1	Text	250
UserDef2	Text	250

tblCoordinator

Name	Type	Size
CoordinatorRecord	LongInteger	4
FacilityRecord	LongInteger	4
Name	Text	100
Address1	Text	250
Address2	Text	250
City	Text	50
State	Text	2
Zip	Text	10
OfficePhone	Text	15
CellPhone	Text	15
Fax	Text	15
Pager	Text	15
Email	Text	250
EmailSubscriber	Yes/No	1
CPRExpDate	Date/Time	8
UserDef1	Text	250
UserDef2	Text	250
DateStart	Date/Time	8
DateEnd	Date/Time	8

tblDirector

Name	Type	Size
DirectorRecord	LongInteger	4
FacilityRecord	LongInteger	4
Name	Text	100
Address1	Text	250
Address2	Text	250
City	Text	50
State	Text	2
Zip	Text	10
OfficePhone	Text	15
CellPhone	Text	15
Fax	Text	15
Pager	Text	15
Email	Text	250
EmailSubscriber	Yes/No	1
License	Text	25
UserDef1	Text	250
UserDef2	Text	250
DateStart	Date/Time	8
DateEnd	Date/Time	8

tblDispatchNotification

Name	Type	Size
CADRecord	Long Integer	4
SendTo	Text	100
EmailAddress	Text	250
FaxNumber	Text	15
SentBy	Text	50
SendersEmail	Text	250
SendersPhone	Text	15

tblElectrodes

Name	Type	Size
PadRecord	Long Integer	4
FacilityRecord	Long Integer	4
PadBrandCode	Long Integer	4
PadModelNumber	Text	20
PadSerialNumber	Text	20
PadLotNumber	Text	20
PadExpirationDate	Date/Time	8
CoordinatorNotified	Yes/No	1
AEDSerialNumber	Text	20
Notes	Memo	-
UserDef1	Text	250
UserDef2	Text	250

tblFacility

Name	Type	Size
FacilityRecord	Long Integer	4
Name	Text	250
Address1	Text	250
Address2	Text	250
City	Text	50
State	Text	2
Zip	Text	10
Phone	Text	15
FacilityType	Long Integer	4
WebSite	Text	250
Email	Text	250
EmailSubscriber	Yes/No	1
UserDef1	Text	250
UserDef2	Text	250
DateStart	Date/Time	8
DateEnd	Date/Time	8

tblHazard

Name	Type	Size
HazardRecord	Long Integer	4
FacilityRecord	Long Integer	4
HazardTypeCode	Long Integer	4
Location	Memo	-
UserDef1	Text	250
UserDef2	Text	250
DateStart	Date/Time	8
DateEnd	Date/Time	8

The following are the lookup data tables, typically used to fill combo boxes or other look-up tables. These are populated by the user, and are specific to their needs. They utilize the prefix identifier with 'lkup' to designate them as 'lookup' tables

lkupAEDBrand

Name	Type	Size
AEDBrandCode	Long Integer	4
AEDBrandText	Text	150
ManufacturerRecord	Long Integer	4

lkupBattery

Name	Type	Size
BatteryBrandCode	Long Integer	4
BatteryBrandText	Text	150
ManufacturerRecord	Long Integer	4

lkupFacilityType

Name	Type	Size
FacilityTypeCode	Long Integer	4
FacilityTypeText	Text	150

lkupHazards

Name	Type	Size
HazardTypeCode	Long Integer	4
HazardTypeText	Text	150

lkupManufacturer

Name	Type	Size
ManifacturerCode	Long Integer	4
Manufacturer	Text	150
Address1	Text	250
Address2	Text	250
City	Text	50
State	Text	2
Zip	Text	10
Phone	Text	15
Fax	Text	15
WebSite	Text	250
Email	Text	250

lkupPads

Name	Type	Size
PadBrandCode	Long Integer	4
PadBrandText	Text	150
ManufacturerRecord	Long Integer	4

lkupUser

Name	Type	Size
UserCode	Long Integer	4
RealName	Text	50
LoginName	Text	20
Password	Text	20
AccessLevel	Integer	2

Robert Austin

2005-01-22T19:17:21